SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_SetSpecNumberToZero]
    (
      @fdSpecID VARCHAR(50),
      @fdSpecType INT
    )
AS 
--	  doo 20110215
--    IF @fdSpecType = 1 
--        UPDATE  dbo.JOL_SpecialityIntroduction
--        SET     fdSpecBachelorNumber = 0
--        WHERE   fdSpecID = @fdSpecID
--    ELSE 
--        IF @fdSpecType = 2 
--            UPDATE  dbo.JOL_SpecialityIntroduction
--            SET     fdSpecMasterNumber = 0
--            WHERE   fdSpecID = @fdSpecID
        UPDATE  dbo.JOL_SpecialityIntroduction
        SET     fdSpecBachelorNumber = 0, fdSpecMasterNumber = 0, fdSpecDoctorNumber = 0
        WHERE   fdSpecID = @fdSpecID

GO
